class CreateOrders < ActiveRecord::Migration
  def change
    create_table :orders do |t|
      t.string :sr
      t.string :name
      t.string :phone
      t.date :order_date
      t.string :machine_type
      t.string :machine_num
      t.string :machine_time
      t.date :machine_date
      t.string :service_type
      t.integer :is_in_release
      t.text :trouble
      t.text :content
      t.string :trouble_num
      t.string :signed_num
      t.string :packing_num
      t.text :advise
      t.float :sales_service_cost
      t.float :component_cost
      t.float :service_cost
      t.float :total_price
      t.string :manager_pic
      t.string :staff_pic
      t.string :customer_pic
      t.string :last_address
      t.integer :is_show ,default:0
      t.integer :status ,default: 0

      t.timestamps null: false
    end
  end
end
